﻿ALTER TABLE public.cms_areas DROP CONSTRAINT fk_areas_portals;
ALTER TABLE public.cms_areas DROP CONSTRAINT fk_areas_users;
ALTER TABLE public.cms_areas DROP CONSTRAINT fk_areas_users1;
ALTER TABLE public.cms_content_categories DROP CONSTRAINT fk_contentcategories_contentcategories;
ALTER TABLE public.cms_content_categories DROP CONSTRAINT fk_contentcategories_portals;
ALTER TABLE public.cms_content_categories DROP CONSTRAINT fk_contentcategories_users;
ALTER TABLE public.cms_content_comments DROP CONSTRAINT fk_contentcomments_contentcomments;
ALTER TABLE public.cms_content_comments DROP CONSTRAINT fk_contentcomments_contentpages;
ALTER TABLE public.cms_content_comments DROP CONSTRAINT fk_contentcomments_users;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT fk_contentpages_contentcategories;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT fk_contentpages_contentpages;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT fk_contentpages_contributors;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT fk_contentpages_languages;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT fk_contentpages_portals;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT fk_contentpages_themes;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT fk_contentpages_users;
ALTER TABLE public.cms_email_templates DROP CONSTRAINT fk_emailtemplates_portals;
ALTER TABLE public.cms_email_templates DROP CONSTRAINT fk_emailtemplates_users;
ALTER TABLE public.cms_feedback_items DROP CONSTRAINT fk_feedbackitems_portals;
ALTER TABLE public.cms_modules DROP CONSTRAINT fk_modules_contentcategories;
ALTER TABLE public.cms_modules DROP CONSTRAINT fk_modules_contentpages;
ALTER TABLE public.cms_modules DROP CONSTRAINT fk_modules_portals;
ALTER TABLE public.cms_portal_resources DROP CONSTRAINT fk_portalresources_portalresourcetypes;
ALTER TABLE public.cms_portal_resources DROP CONSTRAINT fk_portalresources_portals;
ALTER TABLE public.cms_portal_resources DROP CONSTRAINT fk_portalresources_users;
ALTER TABLE public.cms_portals DROP CONSTRAINT fk_portals_languages;
ALTER TABLE public.cms_portals DROP CONSTRAINT fk_portals_themes;
ALTER TABLE public.cms_portals DROP CONSTRAINT fk_portals_users;
ALTER TABLE public.cms_profiles DROP CONSTRAINT fk_profiles_languages;
ALTER TABLE public.cms_profiles DROP CONSTRAINT fk_profiles_stateprovinces;
ALTER TABLE public.cms_profiles DROP CONSTRAINT fk_profiles_tracker_projects;
ALTER TABLE public.cms_profiles DROP CONSTRAINT fk_profiles_users;
ALTER TABLE public.cms_redirects DROP CONSTRAINT fk_redirect301_portals;
ALTER TABLE public.cms_themes DROP CONSTRAINT fk_themes_portals;
ALTER TABLE public.cms_widgets DROP CONSTRAINT fk_widgets_contentcategories;
ALTER TABLE public.cms_widgets DROP CONSTRAINT fk_widgets_contentpages;
ALTER TABLE public.cms_widgets DROP CONSTRAINT fk_widgets_portals;
ALTER TABLE public.cms_widgets DROP CONSTRAINT fk_widgets_users;
ALTER TABLE public.cms_zones DROP CONSTRAINT fk_zones_themes;
ALTER TABLE public.forum_forums DROP CONSTRAINT fk_forums_portals;
ALTER TABLE public.forum_forums DROP CONSTRAINT fk_forums_users;
ALTER TABLE public.forum_posts DROP CONSTRAINT fk_contentcomments_contentcomments;
ALTER TABLE public.forum_posts DROP CONSTRAINT fk_posts_forums;
ALTER TABLE public.forum_posts DROP CONSTRAINT fk_posts_posts;
ALTER TABLE public.forum_posts DROP CONSTRAINT fk_posts_users;
ALTER TABLE public.forum_posts DROP CONSTRAINT fk_posts_users1;
ALTER TABLE public.forum_votes DROP CONSTRAINT fk_votes_posts;
ALTER TABLE public.forum_votes DROP CONSTRAINT fk_votes_users;
ALTER TABLE public.optin_attachments DROP CONSTRAINT fk_attachments_newsletters;
ALTER TABLE public.optin_attachments DROP CONSTRAINT fk_optin_attachments_users;
ALTER TABLE public.optin_link_tracking DROP CONSTRAINT fk_linktracking_newsletters;
ALTER TABLE public.optin_link_tracking DROP CONSTRAINT fk_optin_linktracking_users;
ALTER TABLE public.optin_lists DROP CONSTRAINT fk_optin_lists_portals;
ALTER TABLE public.optin_lists DROP CONSTRAINT fk_optin_lists_users;
ALTER TABLE public.optin_newsletter_lists DROP CONSTRAINT fk_newsletterlists_lists;
ALTER TABLE public.optin_newsletter_lists DROP CONSTRAINT fk_newsletterlists_newsletters;
ALTER TABLE public.optin_newsletters DROP CONSTRAINT fk_optin_newsletters_portals;
ALTER TABLE public.optin_newsletters DROP CONSTRAINT fk_optin_newsletters_users;
ALTER TABLE public.optin_subscribers DROP CONSTRAINT fk_optin_subscribers_portals;
ALTER TABLE public.optin_subscribers_lists DROP CONSTRAINT fk_subscriberslists_lists;
ALTER TABLE public.optin_subscribers_lists DROP CONSTRAINT fk_subscriberslists_subscribers;
ALTER TABLE public.optin_users_lists DROP CONSTRAINT fk_optin_userslists_users;
ALTER TABLE public.optin_users_lists DROP CONSTRAINT fk_userslists_lists;
ALTER TABLE public.social_data DROP CONSTRAINT fk_social_data_users;
ALTER TABLE public.social_images DROP CONSTRAINT fk_social_images_users;
ALTER TABLE public.social_likes DROP CONSTRAINT fk_social_likes_social_messages;
ALTER TABLE public.social_likes DROP CONSTRAINT fk_social_likes_users;
ALTER TABLE public.social_messages DROP CONSTRAINT fk_social_messages_social_messages;
ALTER TABLE public.social_messages DROP CONSTRAINT fk_social_messages_social_messagetypes;
ALTER TABLE public.social_messages DROP CONSTRAINT fk_social_messages_users;
ALTER TABLE public.social_messages DROP CONSTRAINT fk_social_messages_users1;
ALTER TABLE public.store_carts DROP CONSTRAINT cart_product;
ALTER TABLE public.store_carts DROP CONSTRAINT fk_store_carts_portals;
ALTER TABLE public.store_carts DROP CONSTRAINT fk_store_carts_store_pricingoptions;
ALTER TABLE public.store_categories DROP CONSTRAINT fk_store_categories_portals;
ALTER TABLE public.store_order_details DROP CONSTRAINT fk_store_orderdetails_store_pricingoptions;
ALTER TABLE public.store_order_details DROP CONSTRAINT order_orderdetails;
ALTER TABLE public.store_order_details DROP CONSTRAINT orderdetail_product;
ALTER TABLE public.store_orders DROP CONSTRAINT fk_store_orders_payments;
ALTER TABLE public.store_orders DROP CONSTRAINT fk_store_orders_portals;
ALTER TABLE public.store_orders DROP CONSTRAINT fk_store_orders_store_shippingmethodrates;
ALTER TABLE public.store_orders DROP CONSTRAINT fk_store_orders_users;
ALTER TABLE public.store_pricing_options DROP CONSTRAINT fk_store_pricingoptions_portals;
ALTER TABLE public.store_products DROP CONSTRAINT fk_store_products_store_categories;
ALTER TABLE public.store_products_pricing_options DROP CONSTRAINT fk_store_products_pricingoptions_store_pricingoptions;
ALTER TABLE public.store_products_pricing_options DROP CONSTRAINT fk_store_products_pricingoptions_store_products;
ALTER TABLE public.store_shipping_method_rates DROP CONSTRAINT fk_store_shippingmethodrate_store_shippingmethods;
ALTER TABLE public.store_shipping_methods DROP CONSTRAINT fk_store_shippingmethods_portals;
ALTER TABLE public.tracker_bug_attachments DROP CONSTRAINT fk_bugattachments_bugs;
ALTER TABLE public.tracker_bug_comments DROP CONSTRAINT fk_bugcomments_bugs;
ALTER TABLE public.tracker_bug_history DROP CONSTRAINT fk_bughistory_bugs;
ALTER TABLE public.tracker_bug_notifications DROP CONSTRAINT fk_bugnotifications_bugs;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT fk_bugs_bugs;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT fk_bugs_projectcategories;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT fk_bugs_projectmilestones;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT fk_bugs_projectpriorities;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT fk_bugs_projects;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT fk_bugs_projectstatuses;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT fk_tracker_bugs_users;
ALTER TABLE public.tracker_help_pages DROP CONSTRAINT fk_tracker_helppages_contentpages;
ALTER TABLE public.tracker_help_pages DROP CONSTRAINT fk_tracker_helppages_portals;
ALTER TABLE public.tracker_project_categories DROP CONSTRAINT fk_projectcategories_projects;
ALTER TABLE public.tracker_project_custom_field_values DROP CONSTRAINT fk_projectcustomfieldvalues_projectcustomfields;
ALTER TABLE public.tracker_project_custom_field_values DROP CONSTRAINT fk_tracker_projectcustomfieldvalues_tracker_bugs;
ALTER TABLE public.tracker_project_customfields DROP CONSTRAINT fk_projectcustomfields_projects;
ALTER TABLE public.tracker_project_members DROP CONSTRAINT fk_projectmembers_projects;
ALTER TABLE public.tracker_project_members DROP CONSTRAINT fk_tracker_projectmembers_users;
ALTER TABLE public.tracker_project_milestones DROP CONSTRAINT fk_projectmilestones_projects;
ALTER TABLE public.tracker_project_notifications DROP CONSTRAINT fk_tracker_bugattachmentsnotifications_tracker_bugattachments;
ALTER TABLE public.tracker_project_priorities DROP CONSTRAINT fk_projectpriorities_projects;
ALTER TABLE public.tracker_project_statuses DROP CONSTRAINT fk_projectstatus_projects;
ALTER TABLE public.tracker_projects DROP CONSTRAINT fk_tracker_projects_portals;
ALTER TABLE public.tracker_ticket_attachments DROP CONSTRAINT fk_ticketattachments_tickets;
ALTER TABLE public.tracker_ticket_comments DROP CONSTRAINT fk_ticketcomments_tickets;
ALTER TABLE public.tracker_ticket_history DROP CONSTRAINT fk_tickethistory_tickets;
ALTER TABLE public.tracker_ticket_notifications DROP CONSTRAINT fk_ticketnotifications_tickets;
ALTER TABLE public.tracker_tickets DROP CONSTRAINT fk_tracker_ticket_tracker_bugs;
ALTER TABLE public.tracker_tickets DROP CONSTRAINT fk_tracker_ticket_tracker_projectpriorities;
ALTER TABLE public.tracker_tickets DROP CONSTRAINT fk_tracker_ticket_tracker_projects;
ALTER TABLE public.tracker_tickets DROP CONSTRAINT fk_tracker_ticket_tracker_projectstatuses;
ALTER TABLE public.tracker_tickets DROP CONSTRAINT fk_tracker_ticket_users;
ALTER TABLE public.tracker_tickets DROP CONSTRAINT fk_tracker_ticket_users1;
ALTER TABLE public.users DROP CONSTRAINT fk_users_portals;
ALTER TABLE public.usersinroles DROP CONSTRAINT fk__usersinro__rolei__2c3393d0;
ALTER TABLE public.usersinroles DROP CONSTRAINT fk__usersinro__useri__2d27b809;
ALTER TABLE public.weighted_content DROP CONSTRAINT fk_weightedcontent_portals;
ALTER TABLE public.weighted_content DROP CONSTRAINT fk_weightedcontent_users;
ALTER TABLE public.weighted_content_modules DROP CONSTRAINT fk_weightedcontentmodules_modules;
ALTER TABLE public.weighted_content_modules DROP CONSTRAINT fk_weightedcontentmodules_weightedcontent;
ALTER TABLE public.weighted_content_modules_roles DROP CONSTRAINT fk_weightedcontentmodulesroles_roles;
ALTER TABLE public.weighted_content_modules_roles DROP CONSTRAINT fk_weightedcontentmodulesroles_weightedcontentmodules;
ALTER TABLE public.weighted_content_widgets DROP CONSTRAINT fk_weightedcontentwidgets_weightedcontent;
ALTER TABLE public.weighted_content_widgets DROP CONSTRAINT fk_weightedcontentwidgets_widgets;
ALTER TABLE public.weighted_content_widgets_roles DROP CONSTRAINT fk_weightedcontentwidgetsroles_roles;
ALTER TABLE public.weighted_content_widgets_roles DROP CONSTRAINT fk_weightedcontentwidgetsroles_weightedcontentwidgets;
ALTER TABLE public.wiki_contents DROP CONSTRAINT fk_wiki_contents_users;
ALTER TABLE public.wiki_contents DROP CONSTRAINT fk_wiki_contents_wiki_titles;
ALTER TABLE public.wiki_settings DROP CONSTRAINT fk_wiki_settings_portals;
ALTER TABLE public.wiki_titles DROP CONSTRAINT fk_wiki_titles_portals;
ALTER TABLE public.wiki_titles DROP CONSTRAINT fk_wiki_titles_users;
ALTER TABLE public.cms_areas DROP CONSTRAINT areas_pkey;
ALTER TABLE public.cms_content_categories DROP CONSTRAINT contentcategories_pkey;
ALTER TABLE public.cms_content_comments DROP CONSTRAINT contentcomments_pkey;
ALTER TABLE public.cms_content_pages DROP CONSTRAINT contentpages_pkey;
ALTER TABLE public.cms_email_templates DROP CONSTRAINT emailtemplates_pkey;
ALTER TABLE public.cms_feedback_items DROP CONSTRAINT feedbackitems_pkey;
ALTER TABLE public.cms_log DROP CONSTRAINT log_pkey;
ALTER TABLE public.cms_modules DROP CONSTRAINT modules_pkey;
ALTER TABLE public.cms_portal_resource_types DROP CONSTRAINT portalresourcetypes_pkey;
ALTER TABLE public.cms_portal_resources DROP CONSTRAINT portalresources_pkey;
ALTER TABLE public.cms_portals DROP CONSTRAINT portals_pkey;
ALTER TABLE public.cms_profiles DROP CONSTRAINT profiles_pkey;
ALTER TABLE public.cms_redirects DROP CONSTRAINT redirects_pkey;
ALTER TABLE public.cms_search_log DROP CONSTRAINT searchlog_pkey;
ALTER TABLE public.cms_themes DROP CONSTRAINT themes_pkey;
ALTER TABLE public.cms_widgets DROP CONSTRAINT widgets_pkey;
ALTER TABLE public.cms_zones DROP CONSTRAINT zones_pkey;
ALTER TABLE public.countries DROP CONSTRAINT countries_pkey;
ALTER TABLE public.forum_forums DROP CONSTRAINT forum_forums_pkey;
ALTER TABLE public.forum_posts DROP CONSTRAINT forum_posts_pkey;
ALTER TABLE public.forum_votes DROP CONSTRAINT forum_votes_pkey;
ALTER TABLE public.languages DROP CONSTRAINT languages_pkey;
ALTER TABLE public.optin_attachments DROP CONSTRAINT optin_attachments_pkey;
ALTER TABLE public.optin_link_tracking DROP CONSTRAINT optin_linktracking_pkey;
ALTER TABLE public.optin_lists DROP CONSTRAINT optin_lists_pkey;
ALTER TABLE public.optin_newsletter_lists DROP CONSTRAINT optin_newsletterlists_pkey;
ALTER TABLE public.optin_newsletters DROP CONSTRAINT optin_newsletters_pkey;
ALTER TABLE public.optin_subscribers DROP CONSTRAINT optin_subscribers_pkey;
ALTER TABLE public.optin_subscribers_lists DROP CONSTRAINT optin_subscriberslists_pkey;
ALTER TABLE public.optin_users_lists DROP CONSTRAINT optin_userslists_pkey;
ALTER TABLE public.roles DROP CONSTRAINT roles_pkey;
ALTER TABLE public.social_data DROP CONSTRAINT social_data_pkey;
ALTER TABLE public.social_images DROP CONSTRAINT social_images_pkey;
ALTER TABLE public.social_likes DROP CONSTRAINT social_likes_pkey;
ALTER TABLE public.social_messages DROP CONSTRAINT social_messages_pkey;
ALTER TABLE public.social_messagetypes DROP CONSTRAINT social_messagetypes_pkey;
ALTER TABLE public.state_provinces DROP CONSTRAINT stateprovinces_pkey;
ALTER TABLE public.store_carts DROP CONSTRAINT store_carts_pkey;
ALTER TABLE public.store_categories DROP CONSTRAINT store_categories_pkey;
ALTER TABLE public.store_order_details DROP CONSTRAINT store_orderdetails_pkey;
ALTER TABLE public.store_orders DROP CONSTRAINT store_orders_pkey;
ALTER TABLE public.store_payments DROP CONSTRAINT store_payments_pkey;
ALTER TABLE public.store_pricing_options DROP CONSTRAINT store_pricingoptions_pkey;
ALTER TABLE public.store_products DROP CONSTRAINT store_products_pkey;
ALTER TABLE public.store_products_pricing_options DROP CONSTRAINT store_products_pricingoptions_pkey;
ALTER TABLE public.store_shipping_method_rates DROP CONSTRAINT store_shippingmethodrates_pkey;
ALTER TABLE public.store_shipping_methods DROP CONSTRAINT store_shippingmethods_pkey;
ALTER TABLE public.tracker_bug_attachments DROP CONSTRAINT tracker_bugattachments_pkey;
ALTER TABLE public.tracker_bug_comments DROP CONSTRAINT tracker_bugcomments_pkey;
ALTER TABLE public.tracker_bug_history DROP CONSTRAINT tracker_bughistory_pkey;
ALTER TABLE public.tracker_bug_notifications DROP CONSTRAINT tracker_bugnotifications_pkey;
ALTER TABLE public.tracker_bugs DROP CONSTRAINT tracker_bugs_pkey;
ALTER TABLE public.tracker_help_pages DROP CONSTRAINT tracker_helppages_pkey;
ALTER TABLE public.tracker_project_categories DROP CONSTRAINT tracker_projectcategories_pkey;
ALTER TABLE public.tracker_project_custom_field_values DROP CONSTRAINT tracker_projectcustomfieldvalues_pkey;
ALTER TABLE public.tracker_project_customfields DROP CONSTRAINT tracker_projectcustomfields_pkey;
ALTER TABLE public.tracker_project_members DROP CONSTRAINT tracker_projectmembers_pkey;
ALTER TABLE public.tracker_project_milestones DROP CONSTRAINT tracker_projectmilestones_pkey;
ALTER TABLE public.tracker_project_notifications DROP CONSTRAINT tracker_projectnotifications_pkey;
ALTER TABLE public.tracker_project_priorities DROP CONSTRAINT tracker_projectpriorities_pkey;
ALTER TABLE public.tracker_project_statuses DROP CONSTRAINT tracker_projectstatuses_pkey;
ALTER TABLE public.tracker_projects DROP CONSTRAINT tracker_projects_pkey;
ALTER TABLE public.tracker_ticket_attachments DROP CONSTRAINT tracker_ticketattachments_pkey;
ALTER TABLE public.tracker_ticket_comments DROP CONSTRAINT tracker_ticketcomments_pkey;
ALTER TABLE public.tracker_ticket_history DROP CONSTRAINT tracker_tickethistory_pkey;
ALTER TABLE public.tracker_ticket_notifications DROP CONSTRAINT tracker_ticketnotifications_pkey;
ALTER TABLE public.tracker_tickets DROP CONSTRAINT tracker_tickets_pkey;
ALTER TABLE public.users DROP CONSTRAINT users_pkey;
ALTER TABLE public.usersinroles DROP CONSTRAINT usersinroles_pkey;
ALTER TABLE public.weighted_content DROP CONSTRAINT weightedcontent_pkey;
ALTER TABLE public.weighted_content_modules DROP CONSTRAINT weightedcontentmodules_pkey;
ALTER TABLE public.weighted_content_modules_roles DROP CONSTRAINT weightedcontentmodulesroles_pkey;
ALTER TABLE public.weighted_content_widgets DROP CONSTRAINT weightedcontentwidgets_pkey;
ALTER TABLE public.weighted_content_widgets_roles DROP CONSTRAINT weightedcontentwidgetsroles_pkey;
ALTER TABLE public.wiki_contents DROP CONSTRAINT wiki_contents_pkey;
ALTER TABLE public.wiki_settings DROP CONSTRAINT wiki_settings_pkey;
ALTER TABLE public.wiki_titles DROP CONSTRAINT wiki_titles_pkey;
ALTER TABLE public.countries DROP CONSTRAINT countries_twoletterisocode_key;
